SELPLUS hr/open
SHOW user

sql> connect system/sys
sql> conn system/sys

clear screen | cl scr

SET LINESIZE 180			Max  2000
SET PAGESIZE 40

/ to execute Previous Query

SET PAGESIZE 0

&
&& - Fixed

SELECT &a+&b FROM dual;
SELECT &&a+&b FROM dual;

SELECT and hit ENTER to copy

SQL> SELECT employee_id, first_name, hire_date, salary, department_id FROM employees
  2  WHERE department_id = &did;

SET VERIFY ON | OFF

DEFINE i=100;
UNDEFINE i;

TTITLE dep_dtls
BTITLE eop

TTITLE OFF
BTITLE OFF

EDIT | ED   ( avoid ; and use /)   / to execute

LIST | L

COL first_name FOR a10;
COL salary FOR 99,999.99$

--to Run Script

@"D:\IT\Technical\Source_Code\02_Session_Logs\2019_Logs\Script\myscript.sql"

--To Export log
SPOOL "D:\IT\Technical\Source_Code\02_Session_Logs\2019_Logs\Script\mylog.sql"

SPOOL OFF

SET FEEDBACK ON | OFF
SET TIMING  ON  | OFF
SET HEADING OFF | ON


--Explain Plan

SET AUTOT ON
SET AUTOT OFF

help SPOOL
HELP INDEX